{"text_format":"1","workbook":"xlsx","n_sheets":15,"sheets":["Directions","Questionnaire","NW Configuration Service","NW Mgmt Console","NW Settings Migration","Tyler Identity","NW HR Reporting","NW ERP","NW eSuite Services","NW eSuite Websites","DSS","myApprovals","myInspections","NW Web API","NW Report Writer"],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":0,"defined_names":0,"comments":0,"pivot_tables":0},"unopened":[],"bounds":{"document_bytes":16777216,"sheet_cells":100000,"rows_first":2000,"rows_last":500,"rows_between":2000,"halvings":0,"cell_chars":16384,"cell_head_chars":4096},"cells_cut":0,"cells_raw":0,"read":"whole","date_system":"1900"}

{"sheet":"Directions","index":0,"n_rows":1,"n_cols":1,"rows_kept":1,"cut":false,"hidden":false,"merged":[]}
["This workbook is designed to help you map out your Tyler Deploy environment.  The Questionnaire tab will help with how to map out your tentacles on the servers and the answers you provide will also fill out the variables in the subsequent sheets that you can use to help fill out the TylerDeploy configuration site.  This spreadsheet merely provides recommendations based on best practices, but each environment could be unique.\n\nTabs are provided in order of execution.  First fill out the questionairre.  That will help determine your roles and what servers they should be installed on.  That sheet will help populate values to put into Tyler Deploy for each of the applicable software products.  Please note that this spreadsheet runs a macro to help identify your server picture (Columns H and I of the Questionnaire are populated after filling out the questions and clicking the Generate TylerDeploy Recommendations button).  You will likely need to enable macros using the Enable Content button at the top of Excel when you open this spreadsheet.  "]

{"sheet":"Questionnaire","index":1,"n_rows":37,"n_cols":21,"rows_kept":37,"cut":false,"hidden":false,"merged":[]}
["Questions","Answers (Server Name or Yes/No unless otherwise indicated)",null,null,null,null,null,"Server","Software Roles"]
["Do you have a Tyler Infrastructure box for this environment?  If Yes, what is its name?  If no, leave blank.*",null,null,"TylerIPServer?",{"$f":"IF(B2=\"\",\"No\",\"Yes\")","v":"No"},{"$f":"IF(E2=\"Yes\",B2,B8)","v":0},"TylerIdentity (All Roles)","TROVMDEPLOY19T"," TylerIdentity (All Roles), New World ERP (TylerIdentity Role), New World Management Console (TylerIdentity Role), New World Settings Migration (TylerIdentity Role)","Yes","https://confl.tylertech.com/display/NWCOM/Octopus+Deployment+Notes"]
["If you have a Tyler Infrastructure server, what address does its SSL certificate resolve to on the network?  If you do not have a Tyler infrastructure server, populate the Host Header Mapping for the Application Server here.",null,null,"Hub?",{"$f":"IF(B16=\"Yes\",\"Yes\",\"No\")","v":"No"},{"$f":"IF(E3=\"Yes\",IF(E2=\"Yes\",B2,B8),\"No\")","v":"No"},"TylerHub (All Roles)","TROVMDEPLOY19ES"," New World Web API (NWERP-WebAPI Role), New World myInspections (NWERP-myInspections Role), New World myApprovals (NWERP-myApprovals Role), New World eSuite Websites (All Roles), New World Settings Migration (NWERP-WebAPI and NWERP-eSuiteWeb roles)","No"]
["Do you have ReadyForms for this environment?",null,null,"Forms?",{"$f":"IF(B4=\"Yes\",\"Yes\",\"No\")","v":"No"},{"$f":"IF(E5=\"Yes\",IF(E2=\"Yes\",B2,B8),\"No\")","v":"No"},"TCM","TROVMDEPLOY19"," New World ERP Report Writer (NWERP-App-Server Role), New World Configuration Service (NWERP-App-Server Role), NWERP-eSuiteServices (NWERP-App-Server Role), New World Management Console (NWERP-App-Server and NWERP-ElasticSearch roles), New World ERP (NWERP-App-Server Role), New World ERP DSS (NWERP-App-Server Role), New World HR Reporting (NWERP-App-Server Role), New World myInspections (NWERP-App-Server Role), New World myApprovals (NWERP-App-Server Role), New World Settings Migration (NWERP-App-Server Role)"]
["Do you have TCM (Tyler Content Manager) for this environment?",null,null,"TCM?",{"$f":"IF(B5=\"Yes\",\"Yes\",\"No\")","v":"No"},{"$f":"IF(E4=\"Yes\",IF(E2=\"Yes\",B2,B8),\"No\")","v":"No"},"ReadyForms (All Roles)"]
["What is your SQL Server Name?",null,null,"eSuite?",{"$f":"IF(B9=\"\",\"No\",\"Yes\")","v":"No"},{"$f":"IF(B12=\"Yes\",B9,\"No\")","v":"No"},"New World Web API (NWERP-WebAPI Role)"]
["What is your SSRS Server Name? May be the same as SQL.",null,null,null,null,{"$f":"IF(B13=\"Yes\",B8,\"No\")","v":"No"},"New World ERP Report Writer (NWERP-App-Server Role)"]
["What is your App Server Name?",null,null,null,null,{"$f":"IF(B14=\"Yes\",B9,\"No\")","v":"No"},"New World myInspections (NWERP-myInspections Role)"]
["What is your eSuite Server Name?  May be the same as App.  If you don't license eSuite, leave this blank.",null,null,null,null,{"$f":"IF(B15=\"Yes\",B9,\"No\")","v":"No"},"New World myApprovals (NWERP-myApprovals Role)"]
["What address does the SSL certificate on the eSuite server resolve to on your network?  If you don't license eSuite, leave this blank.",null,null,null,null,{"$f":"IF(E6=\"Yes\",B9,\"No\")","v":"No"},"New World eSuite Websites (All Roles)"]
["Do you use Dynamic Reporting in this environment (Optional Module)?",null,null,null,null,{"$f":"B8","v":0},"New World Configuration Service (NWERP-App-Server Role)"]
["Do you use the Utility IVR Interface or Work Orders Interface in this environment?",null,null,null,null,{"$f":"B8","v":0},"NWERP-eSuiteServices (NWERP-App-Server Role)"]
["Do you use Report Writer in this environment (Optional Module)?",null,null,null,null,{"$f":"B8","v":0},"New World Management Console (NWERP-App-Server and NWERP-ElasticSearch roles)"]
["Do you use myInspections in this environment (Optional CD Inspections iPad app)?",null,null,null,null,{"$f":"IF(E6=\"Yes\",B9,\"No\")","v":"No"},"New World Settings Migration (NWERP-WebAPI and NWERP-eSuiteWeb roles)"]
["Do you use myApprovals in this environment (Optional iOS and Android mobile approval app)?",null,null,null,null,{"$f":"IF(E2=\"Yes\",B2,B8)","v":0},"New World ERP (TylerIdentity Role)"]
["Do you or would you like to use Hub in this environment (optional dashboarding software)?",null,null,null,null,{"$f":"B8","v":0},"New World ERP (NWERP-App-Server Role)"]
["Where server does DSS run from (if applicable)?",null,null,null,null,{"$f":"B8","v":0},"New World ERP DSS (NWERP-App-Server Role)"]
["What address does your SSL certificate resolve to on your network for New World ERP (SSL Certificate FQDN Name)?",null,null,null,null,{"$f":"B8","v":0},"New World HR Reporting (NWERP-App-Server Role)"]
["If your New World ERP database sits on a named instance of SQL, enter the instance name here.  For example if the instance sits on a server named SQL and the instance name is Instance1, please enter SQL\\Instance1 here.  If you use the default instance of SQL, leave this blank.",null,null,null,null,{"$f":"B8","v":0},"New World myInspections (NWERP-App-Server Role)"]
["What is your New World ERP Database Name for this environment?",null,null,null,null,{"$f":"B8","v":0},"New World myApprovals (NWERP-App-Server Role)"]
["What is your eSuite Database Name for this environment (if used)?  If not used, leave this blank.",null,null,null,null,{"$f":"IF(E2=\"Yes\",B2,B8)","v":0},"New World Management Console (TylerIdentity Role)"]
["What is your HR Reporting Database Name for this environment (if used)?  If not used, leave this blank.",null,null,null,null,{"$f":"IF(E2=\"Yes\",B2,B8)","v":0},"New World Settings Migration (TylerIdentity Role)"]
["What is your Tyler Identity Database Name for this environment?",null,null,null,null,{"$f":"B8","v":0},"New World Settings Migration (NWERP-App-Server Role)"]
["What SQL User do you use for your SQL connections?  You can find this on the Connections tab on the New World ERP Management Console in the DB Connection area."]
["What environment type is this?  Enter test, train or prod.",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"test"]
["What is the URL for the Tyler Identity Token Server for this environment?  This will default from other values",{"$f":"CONCATENATE(\"https://\",B3,\"/\",B25,\"/tylerid/authtokenserver\")","v":"https:////tylerid/authtokenserver"}]
["What is the name of your SSRS folder?  You can find this on the SSRS tab of the New World ERP Management Console."]
["What domain user do you use to run the NWSAppService on your NWERP Application Server?"]
["Do you integrate with Active Directory for logins to New World ERP?"]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"train"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"prod"]
[]
[]
[]
["* A Tyler Infrastructure box would be a server that is specifically set aside to run products like Tyler Content Manager, ReadyForms, Hub, etc.  Depending on what products the site licenses, this may not be required."]
["**These are recommendations for help in mapping out your environment.  TylerDeploy allows several types of environmental configurations and users can deviate from these recommendations at their discretion.  These recommendations are strictly based on server names, they are assuming that hardware recommendations have been cleared through check.tylertech.com on these servers."]

{"sheet":"NW Configuration Service","index":2,"n_rows":4,"n_cols":2,"rows_kept":4,"cut":false,"hidden":false,"merged":[]}
["Prompt","Recommended Value"]
["SQL Instance",{"$f":"IF(LEN(Questionnaire!B19)>0,Questionnaire!B19,Questionnaire!B6)","v":0}]
["SQL User",{"$f":"Questionnaire!B24","v":0}]
["SQL User Password"]

{"sheet":"NW Mgmt Console","index":3,"n_rows":8,"n_cols":2,"rows_kept":8,"cut":false,"hidden":false,"merged":[]}
["Prompt","Recommended Value"]
["Host Header for Configuration Service",{"$f":"Questionnaire!B18","v":0}]
["Application Server User Name (Domain\\User)",{"$f":"Questionnaire!B28","v":0}]
["Application Server User Password"]
["SQL Instance for Configuration Server Database",{"$f":"IF(LEN(Questionnaire!B19)>0,Questionnaire!B19,Questionnaire!B6)","v":0}]
["SQL Configuration Service Database Name","NWERPConfiguration"]
["SQL User for Configuration Service Database",{"$f":"Questionnaire!B24","v":0}]
["SQL User Password for Configuration Service Database"]

{"sheet":"NW Settings Migration","index":4,"n_rows":9,"n_cols":2,"rows_kept":9,"cut":false,"hidden":false,"merged":[]}
["Prompt","Recommended Value"]
["SQL Instance for Configuration Service Database",{"$f":"IF(LEN(Questionnaire!B19)>0,Questionnaire!B19,Questionnaire!B6)","v":0}]
["SQL Configuration Service Database Name","NWERPConfiguration"]
["SQL User for Configuration Service Database",{"$f":"Questionnaire!B24","v":0}]
["SQL User Password for Configuration Service Database"]
["SQL Server for DSS",{"$f":"IF(LEN(Questionnaire!B19)>0,Questionnaire!B19,Questionnaire!B6)","v":0}]
["Domain User for DSS SQL Server",{"$f":"Questionnaire!B28","v":0}]
["Domain User Password"]
["Migrate DSS","Checked for Prod environments, optional for others"]

{"sheet":"Tyler Identity","index":5,"n_rows":32,"n_cols":3,"rows_kept":32,"cut":false,"hidden":false,"merged":[[17,2,22,2]]}
["Tyler Identity Header Prompt","Recommended Value","Notes"]
["Environment Name",{"$f":"Questionnaire!B25","v":0}]
["Installation Drive","C:\\","Installation Drive for product.  This could vary"]
["Local Authentication Type",{"$f":"IF(Questionnaire!B29=\"Yes\",\"AD\",\"TID\")","v":"TID"},"If using Active Directory, change to AD"]
["AD Domain",null,"If on a workgroup, enter anything here."]
["Configuration Administrator Group Name","TylerAdmins"]
["Host Header",{"$f":"Questionnaire!B3","v":0}]
["Auth Token URL",{"$f":"Questionnaire!B26","v":"https:////tylerid/authtokenserver"}]
["Web Site to Install AuthToken Server","Default Web Site"]
["TID SQL Server instance",{"$f":"IF(LEN(Questionnaire!B19)>0,Questionnaire!B19,Questionnaire!B6)","v":0}]
["SQL Sys Admin User",{"$f":"Questionnaire!B24","v":0}]
["SQL Sys Admin User Password"]
["Tyler ID SQL User"]
["Tyler ID SQL Login Password"]
["Tyler Omnibar URL",{"$f":"CONCATENATE(\"https://\",Questionnaire!B3,\"/\",B2,\"/TylerOmnibar/omnibarui/\")","v":"https:///0/TylerOmnibar/omnibarui/"}]
["Tyler Omnibar Service URL",{"$f":"CONCATENATE(\"https://\",Questionnaire!B3,\"/\",B2,\"/tyleromnibar/omnibarservice/\")","v":"https:///0/tyleromnibar/omnibarservice/"}]
["Use Email as User Name","Unchecked"]
["SMTP \"from\" email address",null,"This set of variables is under the advanced checkbox for Tyler Identity.  These variables come into effect if you are using TID for the authentication type for Tyler Identity.  In that case, they need to be configured.  AD customers do not need to configure these values."]
["SMTP Host"]
["SMTP Port"]
["SMTP: Enable SSL?"]
["Tyler Identity SMTP Username"]
["Tyler Identity SMTP User Password"]
[]
[]
["Tyler Omnibar Header Prompt","Recommended Value"]
["Environment Name",{"$f":"Questionnaire!B25","v":0}]
["Installation Drive","C:\\","Installation Drive for product.  This could vary"]
["Host Header",{"$f":"Questionnaire!B3","v":0}]
["Web site to install omnibar","Default Web Site"]
["URL to Tyler ID Auth Tokens",{"$f":"Questionnaire!B26","v":"https:////tylerid/authtokenserver"}]
["Base Path to Tyler ID Installation",{"$f":"CONCATENATE(B3,\"\\inetpub\\tylerroot\\\",B27,\"\\tylerid\")","v":"C:\\\\inetpub\\tylerroot\\0\\tylerid"}]

{"sheet":"NW HR Reporting","index":6,"n_rows":20,"n_cols":2,"rows_kept":20,"cut":false,"hidden":false,"merged":[]}
["Prompt","Recommended Value"]
["Application Server User Name (Domain\\User)",{"$f":"Questionnaire!B28","v":0}]
["Application Server User Password"]
["SQL Instance for NWERP Database",{"$f":"IF(LEN(Questionnaire!B19)>0,Questionnaire!B19,Questionnaire!B6)","v":0}]
["SQL NWERP Database Name",{"$f":"Questionnaire!B20","v":0}]
["SQL User for NWERP Database",{"$f":"Questionnaire!B24","v":0}]
["SQL User Password for NWERP Database"]
["SQL Instance for HR Reporting Database",{"$f":"IF(LEN(Questionnaire!B19)>0,Questionnaire!B19,Questionnaire!B6)","v":0}]
["SQL HR Reporting Database Name",{"$f":"Questionnaire!B22","v":0}]
["SQL User for HR Reporting Database",{"$f":"Questionnaire!B24","v":0}]
["SQL User Password for HR Reporting Database"]
["SSIS Server for HR Reporting",{"$f":"IF(LEN(Questionnaire!B19)>0,Questionnaire!B19,Questionnaire!B6)","v":0}]
["Domain User for HR Reporting SQL Server",{"$f":"Questionnaire!B28","v":0}]
["Domain User for HR Reporting SQL Server Password"]
["Job Execution Hour",4]
["Job Execution Minute",30]
["SSRS URL",{"$f":"CONCATENATE(\"http://\",Questionnaire!B7,\"/ReportServer\")","v":"http:///ReportServer"}]
["SSRS Folder",{"$f":"Questionnaire!B27","v":0}]
["SSRS User (Domain\\User)",{"$f":"Questionnaire!B28","v":0}]
["SSRS User Password"]

{"sheet":"NW ERP","index":7,"n_rows":29,"n_cols":2,"rows_kept":29,"cut":false,"hidden":false,"merged":[]}
["Prompt","Recommended Value"]
["Host Header",{"$f":"Questionnaire!B18","v":0}]
["Application Server User Name (Example: Domain\\User)",{"$f":"Questionnaire!B28","v":0}]
["Application Server User Password"]
["SQL Instance for Configuration Service Database",{"$f":"IF(LEN(Questionnaire!B19)>0,Questionnaire!B19,Questionnaire!B6)","v":0}]
["SQL Configuration Service Database Name","NWERPConfiguration"]
["SQL User for Configuration Service Database",{"$f":"Questionnaire!B24","v":0}]
["SQL User Password for Configuration Service Database"]
["Enable ArcGIS"]
["ArcGIS Service URL"]
["SQL instance For NWERP Database",{"$f":"IF(LEN(Questionnaire!B19)>0,Questionnaire!B19,Questionnaire!B6)","v":0}]
["SQL NWERP Database Name",{"$f":"Questionnaire!B20","v":0}]
["SQL User for NWERP Database",{"$f":"Questionnaire!B24","v":0}]
["SQL User Password for NWERP Database"]
["Tyler ID URL",{"$f":"Questionnaire!B26","v":"https:////tylerid/authtokenserver"}]
["Tyler ID SQL Instance",{"$f":"IF(LEN(Questionnaire!B19)>0,Questionnaire!B19,Questionnaire!B6)","v":0}]
["Tyler ID Database Name",{"$f":"Questionnaire!B23","v":0}]
["Tyler ID SQL User",{"$f":"Questionnaire!B24","v":0}]
["Tyler ID SQL User Password"]
["Scheduled Reports User (Domain\\User)",{"$f":"Questionnaire!B28","v":0}]
["Scheduled Reports User Password"]
["Server for SQL NWERP Database - Name",{"$f":"Questionnaire!B6","v":0}]
["Server for SQL NWERP Database - User (Domain\\User)",{"$f":"Questionnaire!B28","v":0}]
["Server for SQL NWERP Database - User Password"]
["SSRS Server",{"$f":"Questionnaire!B7","v":0}]
["SSRS URL",{"$f":"CONCATENATE(\"http://\",Questionnaire!B7,\"/ReportServer\")","v":"http:///ReportServer"}]
["SSRS Folder",{"$f":"Questionnaire!B27","v":0}]
["SSRS User (Example: Domain\\User)",{"$f":"Questionnaire!B28","v":0}]
["SSRS User Password"]

{"sheet":"NW eSuite Services","index":8,"n_rows":21,"n_cols":2,"rows_kept":21,"cut":false,"hidden":false,"merged":[]}
["Prompt","Recommended Value"]
["Host Header",{"$f":"Questionnaire!B18","v":0}]
["Application Server User Name (Example: Domain\\User)",{"$f":"Questionnaire!B28","v":0}]
["Application Server User Password"]
["SQL Instance for Configuration Service Database",{"$f":"IF(LEN(Questionnaire!B19)>0,Questionnaire!B19,Questionnaire!B6)","v":0}]
["SQL Configuration Service Database Name","NWERPConfiguration"]
["SQL User for Configuration Service Database",{"$f":"Questionnaire!B24","v":0}]
["SQL User Password for Configuration Service Database"]
["SQL Instance for eSuite Database",{"$f":"IF(LEN(Questionnaire!B19)>0,Questionnaire!B19,Questionnaire!B6)","v":0}]
["SQL eSuite Database Name",{"$f":"Questionnaire!B21","v":0}]
["SQL User for eSuite Database",{"$f":"Questionnaire!B24","v":0}]
["SQL User Password for eSuite Database"]
["Name of eSuite user in NWERP","esuite"]
["SQL Instance for NW ERP Database",{"$f":"IF(LEN(Questionnaire!B19)>0,Questionnaire!B19,Questionnaire!B6)","v":0}]
["SQL NWERP Database Name",{"$f":"Questionnaire!B20","v":0}]
["SQL User for NWERP Database",{"$f":"Questionnaire!B24","v":0}]
["Server for SQL NWERP Database - User Password"]
["SSRS URL",{"$f":"CONCATENATE(\"http://\",Questionnaire!B7,\"/ReportServer\")","v":"http:///ReportServer"}]
["SSRS Folder",{"$f":"Questionnaire!B27","v":0}]
["SSRS User (Example: Domain\\User)",{"$f":"Questionnaire!B28","v":0}]
["SSRS User Password"]

{"sheet":"NW eSuite Websites","index":9,"n_rows":2,"n_cols":2,"rows_kept":2,"cut":false,"hidden":false,"merged":[]}
["Prompt","Recommended Value"]
["Host Header",{"$f":"Questionnaire!B18","v":0}]

{"sheet":"DSS","index":10,"n_rows":16,"n_cols":2,"rows_kept":16,"cut":false,"hidden":false,"merged":[]}
["Prompt","Recommended Value"]
["SQL Instance for NWERP Database",{"$f":"IF(LEN(Questionnaire!B19)>0,Questionnaire!B19,Questionnaire!B6)","v":0}]
["SQL NWERP Database Name",{"$f":"Questionnaire!B20","v":0}]
["SQL User for NWERP Database",{"$f":"Questionnaire!B24","v":0}]
["SQL User Password for NWERP Database"]
["Application Server User Name (Example: Domain\\User)",{"$f":"Questionnaire!B28","v":0}]
["Application Server User Password"]
["SQL Instance for DSS Database",{"$f":"IF(LEN(Questionnaire!B19)>0,Questionnaire!B19,Questionnaire!B6)","v":0}]
["DSS Database Name","Dynamically determined by Tyler Deploy"]
["SQL User for DSS Database",{"$f":"Questionnaire!B24","v":0}]
["SQL User Password for DSS Database"]
["SSIS Server for DSS",{"$f":"Questionnaire!B7","v":0}]
["Domain User for DSS SSIS Server",{"$f":"Questionnaire!B28","v":0}]
["Domain User for DSS SSIS Server Password"]
["SQL Instance for DSS SSAS databases",{"$f":"IF(LEN(Questionnaire!B19)>0,Questionnaire!B19,Questionnaire!B6)","v":0}]
["Prefix for All DSS SSAS Databases","Dynamically determined by Tyler Deploy"]

{"sheet":"myApprovals","index":11,"n_rows":18,"n_cols":2,"rows_kept":18,"cut":false,"hidden":false,"merged":[]}
["Prompt","Recommended Value"]
["myApprovals Host Header",{"$f":"Questionnaire!B10","v":0}]
["ERP Host Header",{"$f":"Questionnaire!B18","v":0}]
["Application Server User Name (Domain\\User)",{"$f":"Questionnaire!B28","v":0}]
["Application Server User Password"]
["Tyler ID URL",{"$f":"Questionnaire!B26","v":"https:////tylerid/authtokenserver"}]
["Tyler ID SQL Instance",{"$f":"IF(LEN(Questionnaire!B19)>0,Questionnaire!B19,Questionnaire!B6)","v":0}]
["Tyler ID Database Name",{"$f":"Questionnaire!B23","v":0}]
["Tyler ID SQL User",{"$f":"Questionnaire!B24","v":0}]
["Tyler ID SQL User Password"]
["SQL Instance for NWERP Database",{"$f":"IF(LEN(Questionnaire!B19)>0,Questionnaire!B19,Questionnaire!B6)","v":0}]
["SQL NWERP Database Name",{"$f":"Questionnaire!B20","v":0}]
["SQL User for NWERP Database",{"$f":"Questionnaire!B24","v":0}]
["SQL User Password fro NWERP Database"]
["SQL Instance for Configuration Service Database",{"$f":"IF(LEN(Questionnaire!B19)>0,Questionnaire!B19,Questionnaire!B6)","v":0}]
["SQL Configuration Service Database Name","NWERPConfiguration"]
["SQL User for Configuration Service Database",{"$f":"Questionnaire!B24","v":0}]
["SQL User Password for Configuration Service Database"]

{"sheet":"myInspections","index":12,"n_rows":14,"n_cols":2,"rows_kept":14,"cut":false,"hidden":false,"merged":[]}
["Prompt","Recommended Value"]
["myInspections Host Header",{"$f":"Questionnaire!B10","v":0}]
["ERP Host Header",{"$f":"Questionnaire!B18","v":0}]
["Application Server User Name (Domain\\User)",{"$f":"Questionnaire!B28","v":0}]
["Application Server User Password"]
["Tyler ID URL",{"$f":"Questionnaire!B26","v":"https:////tylerid/authtokenserver"}]
["Tyler ID SQL Instance",{"$f":"IF(LEN(Questionnaire!B19)>0,Questionnaire!B19,Questionnaire!B6)","v":0}]
["Tyler ID Database Name",{"$f":"Questionnaire!B23","v":0}]
["Tyler ID SQL User",{"$f":"Questionnaire!B24","v":0}]
["Tyler ID SQL User Password"]
["SQL Instance for Configuration Service Database",{"$f":"IF(LEN(Questionnaire!B19)>0,Questionnaire!B19,Questionnaire!B6)","v":0}]
["SQL Configuration Service Database Name","NWERPConfiguration"]
["SQL User for Configuration Service Database",{"$f":"Questionnaire!B24","v":0}]
["SQL User Password for Configuration Service Database"]

{"sheet":"NW Web API","index":13,"n_rows":2,"n_cols":2,"rows_kept":2,"cut":false,"hidden":false,"merged":[]}
["Prompt","Recommended Value"]
["Host Header",{"$f":"Questionnaire!B18","v":0}]

{"sheet":"NW Report Writer","index":14,"n_rows":7,"n_cols":2,"rows_kept":7,"cut":false,"hidden":false,"merged":[]}
["Prompt","Recommended Value"]
["Application Server User Name (Domain\\User)",{"$f":"Questionnaire!B28","v":0}]
["Application Server User Password"]
["SQL Instance for NWERP Database",{"$f":"IF(LEN(Questionnaire!B19)>0,Questionnaire!B19,Questionnaire!B6)","v":0}]
["SQL NWERP Database Name",{"$f":"Questionnaire!B20","v":0}]
["SQL User for NWERP Database",{"$f":"Questionnaire!B24","v":0}]
["SQL User Password for NWERP Database"]